Dataset statistics
| Number of variables | 32 |
|---|---|
| Number of observations | 97373 |
| Missing cells | 495037 |
| Missing cells (%) | 15.9% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 65.3 MiB |
| Average record size in memory | 703.4 B |
Variable types
| DateTime | 1 |
|---|---|
| Categorical | 5 |
| Numeric | 21 |
| Text | 4 |
| Unsupported | 1 |
CANCELLED has constant value "0.0" | Constant |
AIRLINE is highly overall correlated with AIRLINE_CODE and 2 other fields | High correlation |
AIRLINE_CODE is highly overall correlated with AIRLINE and 2 other fields | High correlation |
AIRLINE_DOT is highly overall correlated with AIRLINE and 2 other fields | High correlation |
AIR_TIME is highly overall correlated with CRS_ELAPSED_TIME and 3 other fields | High correlation |
ARR_DELAY is highly overall correlated with DEP_DELAY and 1 other fields | High correlation |
ARR_TIME is highly overall correlated with CRS_ARR_TIME and 4 other fields | High correlation |
CRS_ARR_TIME is highly overall correlated with ARR_TIME and 4 other fields | High correlation |
CRS_DEP_TIME is highly overall correlated with ARR_TIME and 4 other fields | High correlation |
CRS_ELAPSED_TIME is highly overall correlated with AIR_TIME and 2 other fields | High correlation |
DELAY_DUE_CARRIER is highly overall correlated with DIVERTED | High correlation |
DELAY_DUE_LATE_AIRCRAFT is highly overall correlated with DIVERTED | High correlation |
DELAY_DUE_NAS is highly overall correlated with DIVERTED | High correlation |
DELAY_DUE_SECURITY is highly overall correlated with DIVERTED | High correlation |
DELAY_DUE_WEATHER is highly overall correlated with DIVERTED | High correlation |
DEP_DELAY is highly overall correlated with ARR_DELAY | High correlation |
DEP_TIME is highly overall correlated with ARR_TIME and 4 other fields | High correlation |
DISTANCE is highly overall correlated with AIR_TIME and 2 other fields | High correlation |
DIVERTED is highly overall correlated with AIR_TIME and 7 other fields | High correlation |
DOT_CODE is highly overall correlated with AIRLINE and 2 other fields | High correlation |
ELAPSED_TIME is highly overall correlated with AIR_TIME and 3 other fields | High correlation |
WHEELS_OFF is highly overall correlated with ARR_TIME and 4 other fields | High correlation |
WHEELS_ON is highly overall correlated with ARR_TIME and 4 other fields | High correlation |
DIVERTED is highly imbalanced (97.6%) | Imbalance |
CANCELLATION_CODE has 97373 (100.0%) missing values | Missing |
DELAY_DUE_CARRIER has 79381 (81.5%) missing values | Missing |
DELAY_DUE_WEATHER has 79381 (81.5%) missing values | Missing |
DELAY_DUE_NAS has 79381 (81.5%) missing values | Missing |
DELAY_DUE_SECURITY has 79381 (81.5%) missing values | Missing |
DELAY_DUE_LATE_AIRCRAFT has 79381 (81.5%) missing values | Missing |
DELAY_DUE_SECURITY is highly skewed (γ1 = 50.5875775) | Skewed |
CANCELLATION_CODE is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
DEP_DELAY has 4850 (5.0%) zeros | Zeros |
ARR_DELAY has 1853 (1.9%) zeros | Zeros |
DELAY_DUE_CARRIER has 8088 (8.3%) zeros | Zeros |
DELAY_DUE_WEATHER has 16957 (17.4%) zeros | Zeros |
DELAY_DUE_NAS has 9248 (9.5%) zeros | Zeros |
DELAY_DUE_SECURITY has 17890 (18.4%) zeros | Zeros |
DELAY_DUE_LATE_AIRCRAFT has 9369 (9.6%) zeros | Zeros |
Reproduction
| Analysis started | 2025-07-08 18:59:38.583893 |
|---|---|
| Analysis finished | 2025-07-08 19:00:10.232913 |
| Duration | 31.65 seconds |
| Software version | ydata-profiling vv4.10.0 |
| Download configuration | config.json |
FL_DATE
Date
| Distinct | 1704 |
|---|---|
| Distinct (%) | 1.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.5 MiB |
| Minimum | 2019-01-01 00:00:00 |
|---|---|
| Maximum | 2023-08-31 00:00:00 |
AIRLINE
Categorical
HIGH CORRELATION 
| Distinct | 18 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.1 MiB |
| Southwest Airlines Co. | |
|---|---|
| Delta Air Lines Inc. | |
| American Airlines Inc. | |
| SkyWest Airlines Inc. | |
| United Air Lines Inc. | |
| Other values (13) |
Length
| Max length | 34 |
|---|---|
| Median length | 22 |
| Mean length | 19.59916 |
| Min length | 9 |
Characters and Unicode
| Total characters | 1908429 |
|---|---|
| Distinct characters | 43 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Allegiant Air |
|---|---|
| 2nd row | PSA Airlines Inc. |
| 3rd row | Southwest Airlines Co. |
| 4th row | Southwest Airlines Co. |
| 5th row | Delta Air Lines Inc. |
Common Values
| Value | Count | Frequency (%) |
| Southwest Airlines Co. | 18496 | |
| Delta Air Lines Inc. | 12875 | |
| American Airlines Inc. | 12508 | |
| SkyWest Airlines Inc. | 11075 | |
| United Air Lines Inc. | 8314 | |
| Republic Airline | 4796 | 4.9% |
| Envoy Air | 3847 | 4.0% |
| Endeavor Air Inc. | 3669 | 3.8% |
| JetBlue Airways | 3609 | 3.7% |
| PSA Airlines Inc. | 3557 | 3.7% |
| Other values (8) | 14627 |
Length
| Value | Count | Frequency (%) |
| inc | 60552 | |
| airlines | 54810 | |
| air | 34158 | |
| lines | 24322 | |
| southwest | 18496 | 6.2% |
| co | 18496 | 6.2% |
| delta | 12875 | 4.3% |
| american | 12508 | 4.2% |
| skywest | 11075 | 3.7% |
| united | 8314 | 2.8% |
| Other values (18) | 44370 |
Most occurring characters
| Value | Count | Frequency (%) |
| i | 219621 | |
| 202603 | 10.6% | |
| n | 178270 | 9.3% |
| e | 169965 | 8.9% |
| r | 122254 | 6.4% |
| s | 118974 | 6.2% |
| A | 118492 | 6.2% |
| l | 87605 | 4.6% |
| t | 80431 | 4.2% |
| . | 79048 | 4.1% |
| Other values (33) | 531166 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1908429 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| i | 219621 | |
| 202603 | 10.6% | |
| n | 178270 | 9.3% |
| e | 169965 | 8.9% |
| r | 122254 | 6.4% |
| s | 118974 | 6.2% |
| A | 118492 | 6.2% |
| l | 87605 | 4.6% |
| t | 80431 | 4.2% |
| . | 79048 | 4.1% |
| Other values (33) | 531166 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1908429 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| i | 219621 | |
| 202603 | 10.6% | |
| n | 178270 | 9.3% |
| e | 169965 | 8.9% |
| r | 122254 | 6.4% |
| s | 118974 | 6.2% |
| A | 118492 | 6.2% |
| l | 87605 | 4.6% |
| t | 80431 | 4.2% |
| . | 79048 | 4.1% |
| Other values (33) | 531166 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1908429 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| i | 219621 | |
| 202603 | 10.6% | |
| n | 178270 | 9.3% |
| e | 169965 | 8.9% |
| r | 122254 | 6.4% |
| s | 118974 | 6.2% |
| A | 118492 | 6.2% |
| l | 87605 | 4.6% |
| t | 80431 | 4.2% |
| . | 79048 | 4.1% |
| Other values (33) | 531166 |
AIRLINE_DOT
Categorical
HIGH CORRELATION 
| Distinct | 18 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.5 MiB |
| Southwest Airlines Co.: WN | |
|---|---|
| Delta Air Lines Inc.: DL | |
| American Airlines Inc.: AA | |
| SkyWest Airlines Inc.: OO | |
| United Air Lines Inc.: UA | |
| Other values (13) |
Length
| Max length | 38 |
|---|---|
| Median length | 26 |
| Mean length | 23.59916 |
| Min length | 13 |
Characters and Unicode
| Total characters | 2297921 |
|---|---|
| Distinct characters | 55 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Allegiant Air: G4 |
|---|---|
| 2nd row | PSA Airlines Inc.: OH |
| 3rd row | Southwest Airlines Co.: WN |
| 4th row | Southwest Airlines Co.: WN |
| 5th row | Delta Air Lines Inc.: DL |
Common Values
| Value | Count | Frequency (%) |
| Southwest Airlines Co.: WN | 18496 | |
| Delta Air Lines Inc.: DL | 12875 | |
| American Airlines Inc.: AA | 12508 | |
| SkyWest Airlines Inc.: OO | 11075 | |
| United Air Lines Inc.: UA | 8314 | |
| Republic Airline: YX | 4796 | 4.9% |
| Envoy Air: MQ | 3847 | 4.0% |
| Endeavor Air Inc.: 9E | 3669 | 3.8% |
| JetBlue Airways: B6 | 3609 | 3.7% |
| PSA Airlines Inc.: OH | 3557 | 3.7% |
| Other values (8) | 14627 |
Length
| Value | Count | Frequency (%) |
| inc | 60552 | |
| airlines | 54810 | |
| air | 34158 | 8.6% |
| lines | 24322 | 6.1% |
| southwest | 18496 | 4.7% |
| co | 18496 | 4.7% |
| wn | 18496 | 4.7% |
| delta | 12875 | 3.2% |
| dl | 12875 | 3.2% |
| american | 12508 | 3.1% |
| Other values (36) | 129761 |
Most occurring characters
| Value | Count | Frequency (%) |
| 299976 | 13.1% | |
| i | 219621 | 9.6% |
| n | 178270 | 7.8% |
| e | 169965 | 7.4% |
| A | 156195 | 6.8% |
| r | 122254 | 5.3% |
| s | 118974 | 5.2% |
| : | 97373 | 4.2% |
| l | 87605 | 3.8% |
| t | 80431 | 3.5% |
| Other values (45) | 767257 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 2297921 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 299976 | 13.1% | |
| i | 219621 | 9.6% |
| n | 178270 | 7.8% |
| e | 169965 | 7.4% |
| A | 156195 | 6.8% |
| r | 122254 | 5.3% |
| s | 118974 | 5.2% |
| : | 97373 | 4.2% |
| l | 87605 | 3.8% |
| t | 80431 | 3.5% |
| Other values (45) | 767257 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 2297921 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 299976 | 13.1% | |
| i | 219621 | 9.6% |
| n | 178270 | 7.8% |
| e | 169965 | 7.4% |
| A | 156195 | 6.8% |
| r | 122254 | 5.3% |
| s | 118974 | 5.2% |
| : | 97373 | 4.2% |
| l | 87605 | 3.8% |
| t | 80431 | 3.5% |
| Other values (45) | 767257 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 2297921 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 299976 | 13.1% | |
| i | 219621 | 9.6% |
| n | 178270 | 7.8% |
| e | 169965 | 7.4% |
| A | 156195 | 6.8% |
| r | 122254 | 5.3% |
| s | 118974 | 5.2% |
| : | 97373 | 4.2% |
| l | 87605 | 3.8% |
| t | 80431 | 3.5% |
| Other values (45) | 767257 |
AIRLINE_CODE
Categorical
HIGH CORRELATION 
| Distinct | 18 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 5.5 MiB |
| WN | |
|---|---|
| DL | |
| AA | |
| OO | |
| UA | |
| Other values (13) |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Characters and Unicode
| Total characters | 194746 |
|---|---|
| Distinct characters | 22 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | G4 |
|---|---|
| 2nd row | OH |
| 3rd row | WN |
| 4th row | WN |
| 5th row | DL |
Common Values
| Value | Count | Frequency (%) |
| WN | 18496 | |
| DL | 12875 | |
| AA | 12508 | |
| OO | 11075 | |
| UA | 8314 | |
| YX | 4796 | 4.9% |
| MQ | 3847 | 4.0% |
| 9E | 3669 | 3.8% |
| B6 | 3609 | 3.7% |
| OH | 3557 | 3.7% |
| Other values (8) | 14627 |
Length
| Value | Count | Frequency (%) |
| wn | 18496 | |
| dl | 12875 | |
| aa | 12508 | |
| oo | 11075 | |
| ua | 8314 | |
| yx | 4796 | 4.9% |
| mq | 3847 | 4.0% |
| 9e | 3669 | 3.8% |
| b6 | 3609 | 3.7% |
| oh | 3557 | 3.7% |
| Other values (8) | 14627 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 37703 | |
| O | 25707 | |
| N | 21629 | |
| W | 18496 | |
| L | 12875 | 6.6% |
| D | 12875 | 6.6% |
| U | 8314 | 4.3% |
| Y | 6829 | 3.5% |
| 9 | 5817 | 3.0% |
| X | 5451 | 2.8% |
| Other values (12) | 39050 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 194746 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| A | 37703 | |
| O | 25707 | |
| N | 21629 | |
| W | 18496 | |
| L | 12875 | 6.6% |
| D | 12875 | 6.6% |
| U | 8314 | 4.3% |
| Y | 6829 | 3.5% |
| 9 | 5817 | 3.0% |
| X | 5451 | 2.8% |
| Other values (12) | 39050 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 194746 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| A | 37703 | |
| O | 25707 | |
| N | 21629 | |
| W | 18496 | |
| L | 12875 | 6.6% |
| D | 12875 | 6.6% |
| U | 8314 | 4.3% |
| Y | 6829 | 3.5% |
| 9 | 5817 | 3.0% |
| X | 5451 | 2.8% |
| Other values (12) | 39050 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 194746 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| A | 37703 | |
| O | 25707 | |
| N | 21629 | |
| W | 18496 | |
| L | 12875 | 6.6% |
| D | 12875 | 6.6% |
| U | 8314 | 4.3% |
| Y | 6829 | 3.5% |
| 9 | 5817 | 3.0% |
| X | 5451 | 2.8% |
| Other values (12) | 39050 |
DOT_CODE
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 18 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 19977.667 |
| Minimum | 19393 |
|---|---|
| Maximum | 20452 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.5 MiB |
Quantile statistics
| Minimum | 19393 |
|---|---|
| 5-th percentile | 19393 |
| Q1 | 19790 |
| median | 19930 |
| Q3 | 20368 |
| 95-th percentile | 20436 |
| Maximum | 20452 |
| Range | 1059 |
| Interquartile range (IQR) | 578 |
Descriptive statistics
| Standard deviation | 376.45574 |
|---|---|
| Coefficient of variation (CV) | 0.018843829 |
| Kurtosis | -1.3026042 |
| Mean | 19977.667 |
| Median Absolute Deviation (MAD) | 374 |
| Skewness | -0.23202036 |
| Sum | 1.9452853 × 109 |
| Variance | 141718.93 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 19393 | 18496 | |
| 19790 | 12875 | |
| 19805 | 12508 | |
| 20304 | 11075 | |
| 19977 | 8314 | |
| 20452 | 4796 | 4.9% |
| 20398 | 3847 | 4.0% |
| 20363 | 3669 | 3.8% |
| 20409 | 3609 | 3.7% |
| 20397 | 3557 | 3.7% |
| Other values (8) | 14627 |
| Value | Count | Frequency (%) |
| 19393 | 18496 | |
| 19687 | 655 | 0.7% |
| 19690 | 984 | 1.0% |
| 19790 | 12875 | |
| 19805 | 12508 | |
| 19930 | 3389 | 3.5% |
| 19977 | 8314 | |
| 20304 | 11075 | |
| 20363 | 3669 | 3.8% |
| 20366 | 620 | 0.6% |
| Value | Count | Frequency (%) |
| 20452 | 4796 | |
| 20436 | 2148 | |
| 20416 | 3133 | |
| 20409 | 3609 | |
| 20398 | 3847 | |
| 20397 | 3557 | |
| 20378 | 2033 | |
| 20368 | 1665 | 1.7% |
| 20366 | 620 | 0.6% |
| 20363 | 3669 |
FL_NUMBER
Real number (ℝ)
| Distinct | 6537 |
|---|---|
| Distinct (%) | 6.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2510.9279 |
| Minimum | 1 |
|---|---|
| Maximum | 8819 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.5 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 263 |
| Q1 | 1055 |
| median | 2149 |
| Q3 | 3791 |
| 95-th percentile | 5648 |
| Maximum | 8819 |
| Range | 8818 |
| Interquartile range (IQR) | 2736 |
Descriptive statistics
| Standard deviation | 1744.4586 |
|---|---|
| Coefficient of variation (CV) | 0.69474659 |
| Kurtosis | -0.89400184 |
| Mean | 2510.9279 |
| Median Absolute Deviation (MAD) | 1332 |
| Skewness | 0.50618462 |
| Sum | 2.4449659 × 108 |
| Variance | 3043135.9 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 320 | 53 | 0.1% |
| 676 | 52 | 0.1% |
| 334 | 51 | 0.1% |
| 710 | 47 | < 0.1% |
| 350 | 46 | < 0.1% |
| 55 | 46 | < 0.1% |
| 546 | 45 | < 0.1% |
| 61 | 45 | < 0.1% |
| 678 | 44 | < 0.1% |
| 431 | 44 | < 0.1% |
| Other values (6527) | 96900 |
| Value | Count | Frequency (%) |
| 1 | 27 | |
| 2 | 24 | |
| 3 | 30 | |
| 4 | 21 | |
| 5 | 27 | |
| 6 | 31 | |
| 7 | 21 | |
| 8 | 25 | |
| 9 | 14 | |
| 10 | 27 |
| Value | Count | Frequency (%) |
| 8819 | 1 | |
| 8795 | 1 | |
| 8783 | 1 | |
| 8771 | 1 | |
| 7439 | 1 | |
| 7438 | 1 | |
| 7436 | 1 | |
| 7434 | 2 | |
| 7429 | 2 | |
| 7426 | 1 |
ORIGIN
Text
| Distinct | 372 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 5.6 MiB |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 292119 |
|---|---|
| Distinct characters | 26 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 4 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | PGD |
|---|---|
| 2nd row | EWN |
| 3rd row | ABQ |
| 4th row | PIT |
| 5th row | LAX |
| Value | Count | Frequency (%) |
| atl | 5006 | 5.1% |
| dfw | 4310 | 4.4% |
| ord | 3937 | 4.0% |
| den | 3775 | 3.9% |
| clt | 3029 | 3.1% |
| lax | 2814 | 2.9% |
| phx | 2415 | 2.5% |
| sea | 2409 | 2.5% |
| las | 2341 | 2.4% |
| iah | 2138 | 2.2% |
| Other values (362) | 65199 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 32982 | 11.3% |
| L | 27058 | 9.3% |
| S | 24502 | 8.4% |
| D | 23178 | 7.9% |
| T | 16306 | 5.6% |
| C | 14955 | 5.1% |
| O | 14786 | 5.1% |
| M | 12934 | 4.4% |
| F | 12241 | 4.2% |
| W | 11778 | 4.0% |
| Other values (16) | 101399 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 292119 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| A | 32982 | 11.3% |
| L | 27058 | 9.3% |
| S | 24502 | 8.4% |
| D | 23178 | 7.9% |
| T | 16306 | 5.6% |
| C | 14955 | 5.1% |
| O | 14786 | 5.1% |
| M | 12934 | 4.4% |
| F | 12241 | 4.2% |
| W | 11778 | 4.0% |
| Other values (16) | 101399 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 292119 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| A | 32982 | 11.3% |
| L | 27058 | 9.3% |
| S | 24502 | 8.4% |
| D | 23178 | 7.9% |
| T | 16306 | 5.6% |
| C | 14955 | 5.1% |
| O | 14786 | 5.1% |
| M | 12934 | 4.4% |
| F | 12241 | 4.2% |
| W | 11778 | 4.0% |
| Other values (16) | 101399 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 292119 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| A | 32982 | 11.3% |
| L | 27058 | 9.3% |
| S | 24502 | 8.4% |
| D | 23178 | 7.9% |
| T | 16306 | 5.6% |
| C | 14955 | 5.1% |
| O | 14786 | 5.1% |
| M | 12934 | 4.4% |
| F | 12241 | 4.2% |
| W | 11778 | 4.0% |
| Other values (16) | 101399 |
ORIGIN_CITY
Text
| Distinct | 366 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.5 MiB |
Length
| Max length | 34 |
|---|---|
| Median length | 29 |
| Mean length | 13.129677 |
| Min length | 8 |
Characters and Unicode
| Total characters | 1278476 |
|---|---|
| Distinct characters | 58 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 4 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Punta Gorda, FL |
|---|---|
| 2nd row | New Bern/Morehead/Beaufort, NC |
| 3rd row | Albuquerque, NM |
| 4th row | Pittsburgh, PA |
| 5th row | Los Angeles, CA |
| Value | Count | Frequency (%) |
| tx | 10694 | 4.7% |
| ca | 10309 | 4.5% |
| fl | 8328 | 3.7% |
| ga | 5364 | 2.4% |
| il | 5295 | 2.3% |
| chicago | 5056 | 2.2% |
| atlanta | 5006 | 2.2% |
| san | 4921 | 2.2% |
| ny | 4829 | 2.1% |
| new | 4469 | 2.0% |
| Other values (442) | 162431 |
Most occurring characters
| Value | Count | Frequency (%) |
| 129329 | 10.1% | |
| a | 97503 | 7.6% |
| , | 97373 | 7.6% |
| o | 71457 | 5.6% |
| e | 67321 | 5.3% |
| t | 63640 | 5.0% |
| n | 62447 | 4.9% |
| l | 57173 | 4.5% |
| i | 49094 | 3.8% |
| r | 46455 | 3.6% |
| Other values (48) | 536684 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1278476 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 129329 | 10.1% | |
| a | 97503 | 7.6% |
| , | 97373 | 7.6% |
| o | 71457 | 5.6% |
| e | 67321 | 5.3% |
| t | 63640 | 5.0% |
| n | 62447 | 4.9% |
| l | 57173 | 4.5% |
| i | 49094 | 3.8% |
| r | 46455 | 3.6% |
| Other values (48) | 536684 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1278476 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 129329 | 10.1% | |
| a | 97503 | 7.6% |
| , | 97373 | 7.6% |
| o | 71457 | 5.6% |
| e | 67321 | 5.3% |
| t | 63640 | 5.0% |
| n | 62447 | 4.9% |
| l | 57173 | 4.5% |
| i | 49094 | 3.8% |
| r | 46455 | 3.6% |
| Other values (48) | 536684 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1278476 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 129329 | 10.1% | |
| a | 97503 | 7.6% |
| , | 97373 | 7.6% |
| o | 71457 | 5.6% |
| e | 67321 | 5.3% |
| t | 63640 | 5.0% |
| n | 62447 | 4.9% |
| l | 57173 | 4.5% |
| i | 49094 | 3.8% |
| r | 46455 | 3.6% |
| Other values (48) | 536684 |
DEST
Text
| Distinct | 376 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 5.6 MiB |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 292119 |
|---|---|
| Distinct characters | 26 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 5 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | SPI |
|---|---|
| 2nd row | CLT |
| 3rd row | DEN |
| 4th row | STL |
| 5th row | SEA |
| Value | Count | Frequency (%) |
| atl | 5025 | 5.2% |
| dfw | 4117 | 4.2% |
| ord | 4046 | 4.2% |
| den | 3832 | 3.9% |
| clt | 3187 | 3.3% |
| lax | 2742 | 2.8% |
| phx | 2566 | 2.6% |
| las | 2349 | 2.4% |
| sea | 2279 | 2.3% |
| mco | 2112 | 2.2% |
| Other values (366) | 65118 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 32675 | 11.2% |
| L | 27210 | 9.3% |
| S | 24426 | 8.4% |
| D | 23147 | 7.9% |
| T | 16248 | 5.6% |
| C | 15051 | 5.2% |
| O | 15024 | 5.1% |
| M | 13135 | 4.5% |
| F | 12061 | 4.1% |
| P | 11552 | 4.0% |
| Other values (16) | 101590 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 292119 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| A | 32675 | 11.2% |
| L | 27210 | 9.3% |
| S | 24426 | 8.4% |
| D | 23147 | 7.9% |
| T | 16248 | 5.6% |
| C | 15051 | 5.2% |
| O | 15024 | 5.1% |
| M | 13135 | 4.5% |
| F | 12061 | 4.1% |
| P | 11552 | 4.0% |
| Other values (16) | 101590 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 292119 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| A | 32675 | 11.2% |
| L | 27210 | 9.3% |
| S | 24426 | 8.4% |
| D | 23147 | 7.9% |
| T | 16248 | 5.6% |
| C | 15051 | 5.2% |
| O | 15024 | 5.1% |
| M | 13135 | 4.5% |
| F | 12061 | 4.1% |
| P | 11552 | 4.0% |
| Other values (16) | 101590 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 292119 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| A | 32675 | 11.2% |
| L | 27210 | 9.3% |
| S | 24426 | 8.4% |
| D | 23147 | 7.9% |
| T | 16248 | 5.6% |
| C | 15051 | 5.2% |
| O | 15024 | 5.1% |
| M | 13135 | 4.5% |
| F | 12061 | 4.1% |
| P | 11552 | 4.0% |
| Other values (16) | 101590 |
DEST_CITY
Text
| Distinct | 369 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.5 MiB |
Length
| Max length | 34 |
|---|---|
| Median length | 29 |
| Mean length | 13.096413 |
| Min length | 8 |
Characters and Unicode
| Total characters | 1275237 |
|---|---|
| Distinct characters | 58 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 4 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Springfield, IL |
|---|---|
| 2nd row | Charlotte, NC |
| 3rd row | Denver, CO |
| 4th row | St. Louis, MO |
| 5th row | Seattle, WA |
| Value | Count | Frequency (%) |
| tx | 10395 | 4.6% |
| ca | 10270 | 4.5% |
| fl | 8527 | 3.8% |
| il | 5411 | 2.4% |
| ga | 5388 | 2.4% |
| chicago | 5191 | 2.3% |
| atlanta | 5025 | 2.2% |
| san | 4911 | 2.2% |
| ny | 4648 | 2.1% |
| nc | 4510 | 2.0% |
| Other values (445) | 162047 |
Most occurring characters
| Value | Count | Frequency (%) |
| 128950 | 10.1% | |
| a | 97752 | 7.7% |
| , | 97373 | 7.6% |
| o | 71066 | 5.6% |
| e | 67002 | 5.3% |
| t | 63022 | 4.9% |
| n | 62379 | 4.9% |
| l | 56725 | 4.4% |
| i | 48896 | 3.8% |
| r | 45912 | 3.6% |
| Other values (48) | 536160 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1275237 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 128950 | 10.1% | |
| a | 97752 | 7.7% |
| , | 97373 | 7.6% |
| o | 71066 | 5.6% |
| e | 67002 | 5.3% |
| t | 63022 | 4.9% |
| n | 62379 | 4.9% |
| l | 56725 | 4.4% |
| i | 48896 | 3.8% |
| r | 45912 | 3.6% |
| Other values (48) | 536160 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1275237 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 128950 | 10.1% | |
| a | 97752 | 7.7% |
| , | 97373 | 7.6% |
| o | 71066 | 5.6% |
| e | 67002 | 5.3% |
| t | 63022 | 4.9% |
| n | 62379 | 4.9% |
| l | 56725 | 4.4% |
| i | 48896 | 3.8% |
| r | 45912 | 3.6% |
| Other values (48) | 536160 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1275237 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 128950 | 10.1% | |
| a | 97752 | 7.7% |
| , | 97373 | 7.6% |
| o | 71066 | 5.6% |
| e | 67002 | 5.3% |
| t | 63022 | 4.9% |
| n | 62379 | 4.9% |
| l | 56725 | 4.4% |
| i | 48896 | 3.8% |
| r | 45912 | 3.6% |
| Other values (48) | 536160 |
CRS_DEP_TIME
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 1235 |
|---|---|
| Distinct (%) | 1.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1328.0314 |
| Minimum | 4 |
|---|---|
| Maximum | 2359 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.5 MiB |
Quantile statistics
| Minimum | 4 |
|---|---|
| 5-th percentile | 605 |
| Q1 | 915 |
| median | 1320 |
| Q3 | 1730 |
| 95-th percentile | 2120 |
| Maximum | 2359 |
| Range | 2355 |
| Interquartile range (IQR) | 815 |
Descriptive statistics
| Standard deviation | 485.08206 |
|---|---|
| Coefficient of variation (CV) | 0.365264 |
| Kurtosis | -1.0313097 |
| Mean | 1328.0314 |
| Median Absolute Deviation (MAD) | 407 |
| Skewness | 0.088856519 |
| Sum | 1.293144 × 108 |
| Variance | 235304.6 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 600 | 2004 | 2.1% |
| 700 | 1647 | 1.7% |
| 800 | 998 | 1.0% |
| 830 | 691 | 0.7% |
| 900 | 664 | 0.7% |
| 630 | 641 | 0.7% |
| 730 | 631 | 0.6% |
| 1000 | 627 | 0.6% |
| 1100 | 559 | 0.6% |
| 615 | 516 | 0.5% |
| Other values (1225) | 88395 |
| Value | Count | Frequency (%) |
| 4 | 1 | < 0.1% |
| 5 | 2 | < 0.1% |
| 7 | 2 | < 0.1% |
| 8 | 1 | < 0.1% |
| 9 | 1 | < 0.1% |
| 10 | 2 | < 0.1% |
| 14 | 3 | < 0.1% |
| 15 | 9 | |
| 16 | 1 | < 0.1% |
| 18 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 2359 | 112 | |
| 2358 | 10 | < 0.1% |
| 2357 | 3 | < 0.1% |
| 2356 | 8 | < 0.1% |
| 2355 | 52 | |
| 2354 | 1 | < 0.1% |
| 2353 | 2 | < 0.1% |
| 2352 | 3 | < 0.1% |
| 2351 | 3 | < 0.1% |
| 2350 | 28 | < 0.1% |
DEP_TIME
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 1332 |
|---|---|
| Distinct (%) | 1.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1330.8337 |
| Minimum | 1 |
|---|---|
| Maximum | 2400 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.5 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 603 |
| Q1 | 918 |
| median | 1325 |
| Q3 | 1738 |
| 95-th percentile | 2133 |
| Maximum | 2400 |
| Range | 2399 |
| Interquartile range (IQR) | 820 |
Descriptive statistics
| Standard deviation | 498.81487 |
|---|---|
| Coefficient of variation (CV) | 0.37481381 |
| Kurtosis | -0.9639315 |
| Mean | 1330.8337 |
| Median Absolute Deviation (MAD) | 411 |
| Skewness | 0.040479117 |
| Sum | 1.2958727 × 108 |
| Variance | 248816.27 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 555 | 279 | 0.3% |
| 556 | 253 | 0.3% |
| 655 | 227 | 0.2% |
| 557 | 222 | 0.2% |
| 558 | 220 | 0.2% |
| 559 | 214 | 0.2% |
| 554 | 214 | 0.2% |
| 600 | 202 | 0.2% |
| 656 | 198 | 0.2% |
| 700 | 188 | 0.2% |
| Other values (1322) | 95156 |
| Value | Count | Frequency (%) |
| 1 | 13 | |
| 2 | 8 | |
| 3 | 9 | |
| 4 | 14 | |
| 5 | 8 | |
| 6 | 11 | |
| 7 | 9 | |
| 8 | 11 | |
| 9 | 6 | |
| 10 | 10 |
| Value | Count | Frequency (%) |
| 2400 | 8 | < 0.1% |
| 2359 | 9 | |
| 2358 | 16 | |
| 2357 | 20 | |
| 2356 | 14 | |
| 2355 | 18 | |
| 2354 | 9 | |
| 2353 | 19 | |
| 2352 | 14 | |
| 2351 | 20 |
DEP_DELAY
Real number (ℝ)
HIGH CORRELATION  ZEROS 
| Distinct | 588 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 10.138262 |
| Minimum | -81 |
|---|---|
| Maximum | 1512 |
| Zeros | 4850 |
| Zeros (%) | 5.0% |
| Negative | 59436 |
| Negative (%) | 61.0% |
| Memory size | 1.5 MiB |
Quantile statistics
| Minimum | -81 |
|---|---|
| 5-th percentile | -10 |
| Q1 | -6 |
| median | -2 |
| Q3 | 6 |
| 95-th percentile | 71 |
| Maximum | 1512 |
| Range | 1593 |
| Interquartile range (IQR) | 12 |
Descriptive statistics
| Standard deviation | 49.298681 |
|---|---|
| Coefficient of variation (CV) | 4.8626363 |
| Kurtosis | 190.44197 |
| Mean | 10.138262 |
| Median Absolute Deviation (MAD) | 4 |
| Skewness | 10.815252 |
| Sum | 987193 |
| Variance | 2430.36 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| -5 | 8089 | 8.3% |
| -4 | 7515 | 7.7% |
| -3 | 7076 | 7.3% |
| -6 | 6339 | 6.5% |
| -2 | 6270 | 6.4% |
| -1 | 5498 | 5.6% |
| -7 | 5044 | 5.2% |
| 0 | 4850 | 5.0% |
| -8 | 3978 | 4.1% |
| -9 | 2883 | 3.0% |
| Other values (578) | 39831 |
| Value | Count | Frequency (%) |
| -81 | 1 | < 0.1% |
| -42 | 2 | < 0.1% |
| -38 | 1 | < 0.1% |
| -36 | 1 | < 0.1% |
| -35 | 2 | < 0.1% |
| -34 | 2 | < 0.1% |
| -32 | 1 | < 0.1% |
| -29 | 5 | |
| -28 | 1 | < 0.1% |
| -27 | 8 |
| Value | Count | Frequency (%) |
| 1512 | 1 | |
| 1469 | 1 | |
| 1441 | 1 | |
| 1376 | 1 | |
| 1286 | 1 | |
| 1256 | 1 | |
| 1255 | 1 | |
| 1214 | 1 | |
| 1211 | 1 | |
| 1205 | 1 |
TAXI_OUT
Real number (ℝ)
| Distinct | 135 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 16.680045 |
| Minimum | 1 |
|---|---|
| Maximum | 163 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.5 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 8 |
| Q1 | 11 |
| median | 14 |
| Q3 | 19 |
| 95-th percentile | 33 |
| Maximum | 163 |
| Range | 162 |
| Interquartile range (IQR) | 8 |
Descriptive statistics
| Standard deviation | 9.1710014 |
|---|---|
| Coefficient of variation (CV) | 0.54981875 |
| Kurtosis | 23.059615 |
| Mean | 16.680045 |
| Median Absolute Deviation (MAD) | 4 |
| Skewness | 3.4143561 |
| Sum | 1624186 |
| Variance | 84.107267 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 12 | 8093 | 8.3% |
| 13 | 7825 | 8.0% |
| 11 | 7818 | 8.0% |
| 14 | 7156 | 7.3% |
| 10 | 7067 | 7.3% |
| 15 | 6460 | 6.6% |
| 16 | 5450 | 5.6% |
| 9 | 5378 | 5.5% |
| 17 | 4749 | 4.9% |
| 18 | 4013 | 4.1% |
| Other values (125) | 33364 |
| Value | Count | Frequency (%) |
| 1 | 4 | < 0.1% |
| 2 | 3 | < 0.1% |
| 3 | 20 | < 0.1% |
| 4 | 83 | 0.1% |
| 5 | 238 | 0.2% |
| 6 | 780 | 0.8% |
| 7 | 1803 | 1.9% |
| 8 | 3500 | |
| 9 | 5378 | |
| 10 | 7067 |
| Value | Count | Frequency (%) |
| 163 | 1 | |
| 162 | 1 | |
| 158 | 1 | |
| 157 | 2 | |
| 151 | 1 | |
| 150 | 1 | |
| 147 | 1 | |
| 143 | 2 | |
| 142 | 2 | |
| 139 | 1 |
WHEELS_OFF
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 1338 |
|---|---|
| Distinct (%) | 1.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1353.6206 |
| Minimum | 1 |
|---|---|
| Maximum | 2400 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.5 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 618 |
| Q1 | 932 |
| median | 1338 |
| Q3 | 1752 |
| 95-th percentile | 2146 |
| Maximum | 2400 |
| Range | 2399 |
| Interquartile range (IQR) | 820 |
Descriptive statistics
| Standard deviation | 500.4479 |
|---|---|
| Coefficient of variation (CV) | 0.36971061 |
| Kurtosis | -0.89992525 |
| Mean | 1353.6206 |
| Median Absolute Deviation (MAD) | 410 |
| Skewness | 0.0066597414 |
| Sum | 1.318061 × 108 |
| Variance | 250448.1 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 611 | 189 | 0.2% |
| 610 | 164 | 0.2% |
| 608 | 163 | 0.2% |
| 615 | 160 | 0.2% |
| 712 | 149 | 0.2% |
| 715 | 148 | 0.2% |
| 711 | 148 | 0.2% |
| 619 | 147 | 0.2% |
| 607 | 146 | 0.1% |
| 613 | 146 | 0.1% |
| Other values (1328) | 95813 |
| Value | Count | Frequency (%) |
| 1 | 22 | |
| 2 | 19 | |
| 3 | 14 | |
| 4 | 12 | |
| 5 | 20 | |
| 6 | 11 | |
| 7 | 14 | |
| 8 | 18 | |
| 9 | 14 | |
| 10 | 23 |
| Value | Count | Frequency (%) |
| 2400 | 9 | < 0.1% |
| 2359 | 23 | |
| 2358 | 17 | |
| 2357 | 12 | |
| 2356 | 24 | |
| 2355 | 14 | |
| 2354 | 18 | |
| 2353 | 12 | |
| 2352 | 20 | |
| 2351 | 18 |
WHEELS_ON
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 1421 |
|---|---|
| Distinct (%) | 1.5% |
| Missing | 28 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1463.905 |
| Minimum | 1 |
|---|---|
| Maximum | 2400 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.5 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 654 |
| Q1 | 1050 |
| median | 1502 |
| Q3 | 1909 |
| 95-th percentile | 2247 |
| Maximum | 2400 |
| Range | 2399 |
| Interquartile range (IQR) | 859 |
Descriptive statistics
| Standard deviation | 527.43063 |
|---|---|
| Coefficient of variation (CV) | 0.36029019 |
| Kurtosis | -0.43288968 |
| Mean | 1463.905 |
| Median Absolute Deviation (MAD) | 416 |
| Skewness | -0.31773495 |
| Sum | 1.4250384 × 108 |
| Variance | 278183.07 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1820 | 136 | 0.1% |
| 930 | 132 | 0.1% |
| 1651 | 131 | 0.1% |
| 1802 | 124 | 0.1% |
| 1654 | 123 | 0.1% |
| 1836 | 123 | 0.1% |
| 1641 | 121 | 0.1% |
| 1715 | 121 | 0.1% |
| 2113 | 120 | 0.1% |
| 1627 | 120 | 0.1% |
| Other values (1411) | 96094 |
| Value | Count | Frequency (%) |
| 1 | 48 | |
| 2 | 49 | |
| 3 | 44 | |
| 4 | 47 | |
| 5 | 49 | |
| 6 | 36 | |
| 7 | 45 | |
| 8 | 36 | |
| 9 | 31 | |
| 10 | 40 |
| Value | Count | Frequency (%) |
| 2400 | 45 | |
| 2359 | 45 | |
| 2358 | 55 | |
| 2357 | 62 | |
| 2356 | 48 | |
| 2355 | 52 | |
| 2354 | 60 | |
| 2353 | 63 | |
| 2352 | 42 | |
| 2351 | 39 |
TAXI_IN
Real number (ℝ)
| Distinct | 120 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 28 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7.6952899 |
| Minimum | 1 |
|---|---|
| Maximum | 261 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.5 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 4 |
| median | 6 |
| Q3 | 9 |
| 95-th percentile | 18 |
| Maximum | 261 |
| Range | 260 |
| Interquartile range (IQR) | 5 |
Descriptive statistics
| Standard deviation | 6.4810638 |
|---|---|
| Coefficient of variation (CV) | 0.84221178 |
| Kurtosis | 92.748798 |
| Mean | 7.6952899 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 6.088001 |
| Sum | 749098 |
| Variance | 42.004188 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 4 | 15144 | |
| 5 | 14174 | |
| 6 | 11318 | |
| 3 | 10444 | |
| 7 | 9078 | |
| 8 | 6843 | |
| 9 | 5283 | 5.4% |
| 10 | 4148 | 4.3% |
| 11 | 3304 | 3.4% |
| 2 | 3062 | 3.1% |
| Other values (110) | 14547 |
| Value | Count | Frequency (%) |
| 1 | 183 | 0.2% |
| 2 | 3062 | 3.1% |
| 3 | 10444 | |
| 4 | 15144 | |
| 5 | 14174 | |
| 6 | 11318 | |
| 7 | 9078 | |
| 8 | 6843 | |
| 9 | 5283 | 5.4% |
| 10 | 4148 | 4.3% |
| Value | Count | Frequency (%) |
| 261 | 1 | |
| 187 | 1 | |
| 184 | 1 | |
| 177 | 1 | |
| 173 | 1 | |
| 160 | 1 | |
| 155 | 1 | |
| 153 | 1 | |
| 151 | 1 | |
| 145 | 1 |
CRS_ARR_TIME
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 1327 |
|---|---|
| Distinct (%) | 1.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1490.4567 |
| Minimum | 1 |
|---|---|
| Maximum | 2359 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.5 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 725 |
| Q1 | 1108 |
| median | 1517 |
| Q3 | 1917 |
| 95-th percentile | 2254 |
| Maximum | 2359 |
| Range | 2358 |
| Interquartile range (IQR) | 809 |
Descriptive statistics
| Standard deviation | 512.11088 |
|---|---|
| Coefficient of variation (CV) | 0.34359325 |
| Kurtosis | -0.4525262 |
| Mean | 1490.4567 |
| Median Absolute Deviation (MAD) | 405 |
| Skewness | -0.28411138 |
| Sum | 1.4513024 × 108 |
| Variance | 262257.55 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2359 | 317 | 0.3% |
| 950 | 288 | 0.3% |
| 1900 | 279 | 0.3% |
| 1000 | 270 | 0.3% |
| 2000 | 258 | 0.3% |
| 1835 | 258 | 0.3% |
| 1400 | 257 | 0.3% |
| 1555 | 256 | 0.3% |
| 2100 | 255 | 0.3% |
| 1800 | 251 | 0.3% |
| Other values (1317) | 94684 |
| Value | Count | Frequency (%) |
| 1 | 23 | < 0.1% |
| 2 | 27 | < 0.1% |
| 3 | 30 | < 0.1% |
| 4 | 20 | < 0.1% |
| 5 | 80 | |
| 6 | 27 | < 0.1% |
| 7 | 16 | < 0.1% |
| 8 | 23 | < 0.1% |
| 9 | 19 | < 0.1% |
| 10 | 84 |
| Value | Count | Frequency (%) |
| 2359 | 317 | |
| 2358 | 101 | 0.1% |
| 2357 | 94 | 0.1% |
| 2356 | 72 | 0.1% |
| 2355 | 163 | |
| 2354 | 67 | 0.1% |
| 2353 | 65 | 0.1% |
| 2352 | 69 | 0.1% |
| 2351 | 50 | 0.1% |
| 2350 | 139 |
ARR_TIME
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 1410 |
|---|---|
| Distinct (%) | 1.4% |
| Missing | 28 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1467.1255 |
| Minimum | 1 |
|---|---|
| Maximum | 2400 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.5 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 652 |
| Q1 | 1053 |
| median | 1506 |
| Q3 | 1913 |
| 95-th percentile | 2249 |
| Maximum | 2400 |
| Range | 2399 |
| Interquartile range (IQR) | 860 |
Descriptive statistics
| Standard deviation | 532.51335 |
|---|---|
| Coefficient of variation (CV) | 0.36296373 |
| Kurtosis | -0.35065461 |
| Mean | 1467.1255 |
| Median Absolute Deviation (MAD) | 413 |
| Skewness | -0.36097268 |
| Sum | 1.4281733 × 108 |
| Variance | 283570.47 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1115 | 130 | 0.1% |
| 1343 | 129 | 0.1% |
| 1655 | 123 | 0.1% |
| 1020 | 123 | 0.1% |
| 1052 | 122 | 0.1% |
| 1840 | 122 | 0.1% |
| 1230 | 122 | 0.1% |
| 1547 | 121 | 0.1% |
| 1550 | 121 | 0.1% |
| 944 | 121 | 0.1% |
| Other values (1400) | 96111 |
| Value | Count | Frequency (%) |
| 1 | 67 | |
| 2 | 50 | |
| 3 | 61 | |
| 4 | 42 | |
| 5 | 62 | |
| 6 | 40 | |
| 7 | 54 | |
| 8 | 39 | |
| 9 | 48 | |
| 10 | 60 |
| Value | Count | Frequency (%) |
| 2400 | 48 | |
| 2359 | 43 | |
| 2358 | 71 | |
| 2357 | 59 | |
| 2356 | 56 | |
| 2355 | 53 | |
| 2354 | 59 | |
| 2353 | 62 | |
| 2352 | 63 | |
| 2351 | 68 |
ARR_DELAY
Real number (ℝ)
HIGH CORRELATION  ZEROS 
| Distinct | 613 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 225 |
| Missing (%) | 0.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.3537592 |
| Minimum | -88 |
|---|---|
| Maximum | 1520 |
| Zeros | 1853 |
| Zeros (%) | 1.9% |
| Negative | 62508 |
| Negative (%) | 64.2% |
| Memory size | 1.5 MiB |
Quantile statistics
| Minimum | -88 |
|---|---|
| 5-th percentile | -27 |
| Q1 | -15 |
| median | -7 |
| Q3 | 7 |
| 95-th percentile | 70 |
| Maximum | 1520 |
| Range | 1608 |
| Interquartile range (IQR) | 22 |
Descriptive statistics
| Standard deviation | 51.360244 |
|---|---|
| Coefficient of variation (CV) | 11.796758 |
| Kurtosis | 163.6387 |
| Mean | 4.3537592 |
| Median Absolute Deviation (MAD) | 10 |
| Skewness | 9.7045591 |
| Sum | 422959 |
| Variance | 2637.8747 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| -11 | 2861 | 2.9% |
| -12 | 2845 | 2.9% |
| -13 | 2834 | 2.9% |
| -9 | 2825 | 2.9% |
| -10 | 2787 | 2.9% |
| -7 | 2753 | 2.8% |
| -14 | 2747 | 2.8% |
| -8 | 2690 | 2.8% |
| -15 | 2631 | 2.7% |
| -16 | 2534 | 2.6% |
| Other values (603) | 69641 |
| Value | Count | Frequency (%) |
| -88 | 1 | < 0.1% |
| -68 | 1 | < 0.1% |
| -67 | 1 | < 0.1% |
| -66 | 2 | < 0.1% |
| -63 | 1 | < 0.1% |
| -62 | 2 | < 0.1% |
| -61 | 4 | |
| -60 | 3 | < 0.1% |
| -59 | 9 | |
| -58 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 1520 | 1 | |
| 1473 | 1 | |
| 1458 | 1 | |
| 1371 | 1 | |
| 1285 | 1 | |
| 1270 | 1 | |
| 1247 | 1 | |
| 1207 | 1 | |
| 1200 | 1 | |
| 1199 | 1 |
CANCELLED
Categorical
CONSTANT 
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 5.6 MiB |
| 0.0 |
|---|
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 292119 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0.0 |
|---|---|
| 2nd row | 0.0 |
| 3rd row | 0.0 |
| 4th row | 0.0 |
| 5th row | 0.0 |
Common Values
| Value | Count | Frequency (%) |
| 0.0 | 97373 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0.0 | 97373 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 194746 | |
| . | 97373 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 292119 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 194746 | |
| . | 97373 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 292119 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 194746 | |
| . | 97373 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 292119 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 194746 | |
| . | 97373 |
CANCELLATION_CODE
Unsupported
MISSING  REJECTED  UNSUPPORTED 
| Missing | 97373 |
|---|---|
| Missing (%) | 100.0% |
| Memory size | 1.5 MiB |
DIVERTED
Categorical
HIGH CORRELATION  IMBALANCE 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 5.6 MiB |
| 0.0 | |
|---|---|
| 1.0 | 225 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 292119 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0.0 |
|---|---|
| 2nd row | 0.0 |
| 3rd row | 0.0 |
| 4th row | 0.0 |
| 5th row | 0.0 |
Common Values
| Value | Count | Frequency (%) |
| 0.0 | 97148 | |
| 1.0 | 225 | 0.2% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0.0 | 97148 | |
| 1.0 | 225 | 0.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 194521 | |
| . | 97373 | |
| 1 | 225 | 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 292119 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 194521 | |
| . | 97373 | |
| 1 | 225 | 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 292119 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 194521 | |
| . | 97373 | |
| 1 | 225 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 292119 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 194521 | |
| . | 97373 | |
| 1 | 225 | 0.1% |
CRS_ELAPSED_TIME
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 501 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 142.8576 |
| Minimum | 20 |
|---|---|
| Maximum | 695 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.5 MiB |
Quantile statistics
| Minimum | 20 |
|---|---|
| 5-th percentile | 64 |
| Q1 | 90 |
| median | 125 |
| Q3 | 173 |
| 95-th percentile | 301 |
| Maximum | 695 |
| Range | 675 |
| Interquartile range (IQR) | 83 |
Descriptive statistics
| Standard deviation | 71.980176 |
|---|---|
| Coefficient of variation (CV) | 0.50385962 |
| Kurtosis | 2.5880795 |
| Mean | 142.8576 |
| Median Absolute Deviation (MAD) | 40 |
| Skewness | 1.444716 |
| Sum | 13910473 |
| Variance | 5181.1458 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 90 | 1864 | 1.9% |
| 85 | 1766 | 1.8% |
| 80 | 1679 | 1.7% |
| 70 | 1516 | 1.6% |
| 75 | 1453 | 1.5% |
| 95 | 1420 | 1.5% |
| 115 | 1235 | 1.3% |
| 105 | 1230 | 1.3% |
| 120 | 1202 | 1.2% |
| 110 | 1195 | 1.2% |
| Other values (491) | 82813 |
| Value | Count | Frequency (%) |
| 20 | 3 | |
| 21 | 2 | |
| 23 | 1 | < 0.1% |
| 24 | 1 | < 0.1% |
| 25 | 3 | |
| 26 | 3 | |
| 29 | 1 | < 0.1% |
| 30 | 2 | |
| 32 | 4 | |
| 33 | 3 |
| Value | Count | Frequency (%) |
| 695 | 1 | |
| 684 | 1 | |
| 680 | 1 | |
| 675 | 2 | |
| 670 | 2 | |
| 665 | 1 | |
| 660 | 2 | |
| 652 | 1 | |
| 650 | 2 | |
| 646 | 1 |
ELAPSED_TIME
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 514 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 225 |
| Missing (%) | 0.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 137.07864 |
| Minimum | 17 |
|---|---|
| Maximum | 706 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.5 MiB |
Quantile statistics
| Minimum | 17 |
|---|---|
| 5-th percentile | 56 |
| Q1 | 85 |
| median | 120 |
| Q3 | 168 |
| 95-th percentile | 293 |
| Maximum | 706 |
| Range | 689 |
| Interquartile range (IQR) | 83 |
Descriptive statistics
| Standard deviation | 72.041746 |
|---|---|
| Coefficient of variation (CV) | 0.52555048 |
| Kurtosis | 2.5343943 |
| Mean | 137.07864 |
| Median Absolute Deviation (MAD) | 40 |
| Skewness | 1.4217463 |
| Sum | 13316916 |
| Variance | 5190.0132 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 87 | 798 | 0.8% |
| 79 | 780 | 0.8% |
| 85 | 778 | 0.8% |
| 83 | 773 | 0.8% |
| 76 | 764 | 0.8% |
| 82 | 760 | 0.8% |
| 81 | 757 | 0.8% |
| 75 | 755 | 0.8% |
| 72 | 750 | 0.8% |
| 77 | 747 | 0.8% |
| Other values (504) | 89486 |
| Value | Count | Frequency (%) |
| 17 | 1 | < 0.1% |
| 18 | 1 | < 0.1% |
| 19 | 1 | < 0.1% |
| 21 | 1 | < 0.1% |
| 22 | 2 | < 0.1% |
| 23 | 1 | < 0.1% |
| 24 | 2 | < 0.1% |
| 25 | 5 | |
| 26 | 3 | < 0.1% |
| 28 | 9 |
| Value | Count | Frequency (%) |
| 706 | 1 | |
| 696 | 1 | |
| 687 | 1 | |
| 682 | 1 | |
| 676 | 1 | |
| 668 | 1 | |
| 657 | 1 | |
| 648 | 1 | |
| 644 | 1 | |
| 641 | 1 |
AIR_TIME
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 492 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 225 |
| Missing (%) | 0.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 112.71605 |
| Minimum | 9 |
|---|---|
| Maximum | 669 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.5 MiB |
Quantile statistics
| Minimum | 9 |
|---|---|
| 5-th percentile | 35 |
| Q1 | 62 |
| median | 95 |
| Q3 | 142 |
| 95-th percentile | 267 |
| Maximum | 669 |
| Range | 660 |
| Interquartile range (IQR) | 80 |
Descriptive statistics
| Standard deviation | 70.10449 |
|---|---|
| Coefficient of variation (CV) | 0.62195658 |
| Kurtosis | 2.6192588 |
| Mean | 112.71605 |
| Median Absolute Deviation (MAD) | 38 |
| Skewness | 1.4556215 |
| Sum | 10950139 |
| Variance | 4914.6396 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 61 | 860 | 0.9% |
| 43 | 858 | 0.9% |
| 63 | 851 | 0.9% |
| 65 | 835 | 0.9% |
| 60 | 832 | 0.9% |
| 58 | 828 | 0.9% |
| 55 | 827 | 0.8% |
| 59 | 824 | 0.8% |
| 53 | 818 | 0.8% |
| 66 | 811 | 0.8% |
| Other values (482) | 88804 |
| Value | Count | Frequency (%) |
| 9 | 4 | < 0.1% |
| 10 | 4 | < 0.1% |
| 11 | 2 | < 0.1% |
| 12 | 2 | < 0.1% |
| 13 | 4 | < 0.1% |
| 14 | 3 | < 0.1% |
| 15 | 6 | < 0.1% |
| 16 | 15 | < 0.1% |
| 17 | 29 | |
| 18 | 49 |
| Value | Count | Frequency (%) |
| 669 | 1 | |
| 659 | 1 | |
| 657 | 1 | |
| 654 | 2 | |
| 634 | 1 | |
| 623 | 1 | |
| 621 | 1 | |
| 614 | 1 | |
| 611 | 1 | |
| 606 | 1 |
DISTANCE
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 1607 |
|---|---|
| Distinct (%) | 1.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 814.12611 |
| Minimum | 29 |
|---|---|
| Maximum | 5812 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.5 MiB |
Quantile statistics
| Minimum | 29 |
|---|---|
| 5-th percentile | 175 |
| Q1 | 387 |
| median | 657 |
| Q3 | 1050 |
| 95-th percentile | 2158 |
| Maximum | 5812 |
| Range | 5783 |
| Interquartile range (IQR) | 663 |
Descriptive statistics
| Standard deviation | 591.63469 |
|---|---|
| Coefficient of variation (CV) | 0.72671136 |
| Kurtosis | 2.8922065 |
| Mean | 814.12611 |
| Median Absolute Deviation (MAD) | 320 |
| Skewness | 1.5081882 |
| Sum | 79273902 |
| Variance | 350031.61 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 337 | 618 | 0.6% |
| 399 | 485 | 0.5% |
| 296 | 481 | 0.5% |
| 594 | 409 | 0.4% |
| 224 | 398 | 0.4% |
| 404 | 391 | 0.4% |
| 214 | 384 | 0.4% |
| 862 | 353 | 0.4% |
| 733 | 352 | 0.4% |
| 588 | 347 | 0.4% |
| Other values (1597) | 93155 |
| Value | Count | Frequency (%) |
| 29 | 1 | < 0.1% |
| 30 | 1 | < 0.1% |
| 31 | 12 | < 0.1% |
| 41 | 2 | < 0.1% |
| 45 | 10 | < 0.1% |
| 50 | 3 | < 0.1% |
| 54 | 2 | < 0.1% |
| 61 | 4 | < 0.1% |
| 66 | 6 | < 0.1% |
| 67 | 56 |
| Value | Count | Frequency (%) |
| 5812 | 1 | < 0.1% |
| 5095 | 5 | < 0.1% |
| 4983 | 13 | |
| 4962 | 3 | < 0.1% |
| 4904 | 2 | < 0.1% |
| 4817 | 4 | < 0.1% |
| 4757 | 1 | < 0.1% |
| 4678 | 2 | < 0.1% |
| 4502 | 12 | |
| 4475 | 1 | < 0.1% |
DELAY_DUE_CARRIER
Real number (ℝ)
HIGH CORRELATION  MISSING  ZEROS 
| Distinct | 422 |
|---|---|
| Distinct (%) | 2.3% |
| Missing | 79381 |
| Missing (%) | 81.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 24.91285 |
| Minimum | 0 |
|---|---|
| Maximum | 1473 |
| Zeros | 8088 |
| Zeros (%) | 8.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.5 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 4 |
| Q3 | 23 |
| 95-th percentile | 105 |
| Maximum | 1473 |
| Range | 1473 |
| Interquartile range (IQR) | 23 |
Descriptive statistics
| Standard deviation | 71.923245 |
|---|---|
| Coefficient of variation (CV) | 2.8869938 |
| Kurtosis | 104.50496 |
| Mean | 24.91285 |
| Median Absolute Deviation (MAD) | 4 |
| Skewness | 8.6833266 |
| Sum | 448232 |
| Variance | 5172.9531 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 8088 | 8.3% |
| 2 | 312 | 0.3% |
| 6 | 300 | 0.3% |
| 3 | 297 | 0.3% |
| 15 | 293 | 0.3% |
| 5 | 285 | 0.3% |
| 1 | 284 | 0.3% |
| 16 | 276 | 0.3% |
| 4 | 257 | 0.3% |
| 9 | 256 | 0.3% |
| Other values (412) | 7344 | 7.5% |
| (Missing) | 79381 |
| Value | Count | Frequency (%) |
| 0 | 8088 | |
| 1 | 284 | 0.3% |
| 2 | 312 | 0.3% |
| 3 | 297 | 0.3% |
| 4 | 257 | 0.3% |
| 5 | 285 | 0.3% |
| 6 | 300 | 0.3% |
| 7 | 249 | 0.3% |
| 8 | 240 | 0.2% |
| 9 | 256 | 0.3% |
| Value | Count | Frequency (%) |
| 1473 | 1 | |
| 1458 | 1 | |
| 1376 | 1 | |
| 1256 | 1 | |
| 1155 | 1 | |
| 1147 | 1 | |
| 1121 | 1 | |
| 1115 | 1 | |
| 1088 | 1 | |
| 1066 | 1 |
DELAY_DUE_WEATHER
Real number (ℝ)
HIGH CORRELATION  MISSING  ZEROS 
| Distinct | 224 |
|---|---|
| Distinct (%) | 1.2% |
| Missing | 79381 |
| Missing (%) | 81.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.8727768 |
| Minimum | 0 |
|---|---|
| Maximum | 1285 |
| Zeros | 16957 |
| Zeros (%) | 17.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.5 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 7 |
| Maximum | 1285 |
| Range | 1285 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 30.007417 |
|---|---|
| Coefficient of variation (CV) | 7.7482951 |
| Kurtosis | 538.35721 |
| Mean | 3.8727768 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 18.894339 |
| Sum | 69679 |
| Variance | 900.4451 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 16957 | 17.4% |
| 2 | 24 | < 0.1% |
| 7 | 22 | < 0.1% |
| 16 | 22 | < 0.1% |
| 6 | 21 | < 0.1% |
| 8 | 20 | < 0.1% |
| 9 | 19 | < 0.1% |
| 3 | 19 | < 0.1% |
| 32 | 19 | < 0.1% |
| 18 | 18 | < 0.1% |
| Other values (214) | 851 | 0.9% |
| (Missing) | 79381 |
| Value | Count | Frequency (%) |
| 0 | 16957 | |
| 1 | 17 | < 0.1% |
| 2 | 24 | < 0.1% |
| 3 | 19 | < 0.1% |
| 4 | 16 | < 0.1% |
| 5 | 17 | < 0.1% |
| 6 | 21 | < 0.1% |
| 7 | 22 | < 0.1% |
| 8 | 20 | < 0.1% |
| 9 | 19 | < 0.1% |
| Value | Count | Frequency (%) |
| 1285 | 1 | |
| 1059 | 1 | |
| 1000 | 1 | |
| 989 | 1 | |
| 825 | 1 | |
| 780 | 1 | |
| 733 | 1 | |
| 586 | 1 | |
| 565 | 1 | |
| 554 | 1 |
DELAY_DUE_NAS
Real number (ℝ)
HIGH CORRELATION  MISSING  ZEROS 
| Distinct | 252 |
|---|---|
| Distinct (%) | 1.4% |
| Missing | 79381 |
| Missing (%) | 81.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 13.325311 |
| Minimum | 0 |
|---|---|
| Maximum | 1207 |
| Zeros | 9248 |
| Zeros (%) | 9.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.5 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 17 |
| 95-th percentile | 56 |
| Maximum | 1207 |
| Range | 1207 |
| Interquartile range (IQR) | 17 |
Descriptive statistics
| Standard deviation | 33.717869 |
|---|---|
| Coefficient of variation (CV) | 2.5303626 |
| Kurtosis | 260.9311 |
| Mean | 13.325311 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 11.443701 |
| Sum | 239749 |
| Variance | 1136.8947 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 9248 | 9.5% |
| 1 | 449 | 0.5% |
| 15 | 345 | 0.4% |
| 3 | 319 | 0.3% |
| 17 | 311 | 0.3% |
| 16 | 305 | 0.3% |
| 2 | 303 | 0.3% |
| 5 | 287 | 0.3% |
| 6 | 287 | 0.3% |
| 18 | 279 | 0.3% |
| Other values (242) | 5859 | 6.0% |
| (Missing) | 79381 |
| Value | Count | Frequency (%) |
| 0 | 9248 | |
| 1 | 449 | 0.5% |
| 2 | 303 | 0.3% |
| 3 | 319 | 0.3% |
| 4 | 278 | 0.3% |
| 5 | 287 | 0.3% |
| 6 | 287 | 0.3% |
| 7 | 260 | 0.3% |
| 8 | 236 | 0.2% |
| 9 | 203 | 0.2% |
| Value | Count | Frequency (%) |
| 1207 | 1 | |
| 998 | 1 | |
| 978 | 1 | |
| 880 | 1 | |
| 865 | 1 | |
| 818 | 1 | |
| 696 | 1 | |
| 539 | 1 | |
| 442 | 1 | |
| 439 | 1 |
DELAY_DUE_SECURITY
Real number (ℝ)
HIGH CORRELATION  MISSING  SKEWED  ZEROS 
| Distinct | 45 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 79381 |
| Missing (%) | 81.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.13939529 |
| Minimum | 0 |
|---|---|
| Maximum | 249 |
| Zeros | 17890 |
| Zeros (%) | 18.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.5 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 249 |
| Range | 249 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 3.3412146 |
|---|---|
| Coefficient of variation (CV) | 23.969351 |
| Kurtosis | 3260.5075 |
| Mean | 0.13939529 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 50.587577 |
| Sum | 2508 |
| Variance | 11.163715 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 17890 | 18.4% |
| 10 | 7 | < 0.1% |
| 1 | 7 | < 0.1% |
| 17 | 6 | < 0.1% |
| 14 | 5 | < 0.1% |
| 11 | 5 | < 0.1% |
| 15 | 5 | < 0.1% |
| 7 | 4 | < 0.1% |
| 5 | 4 | < 0.1% |
| 20 | 4 | < 0.1% |
| Other values (35) | 55 | 0.1% |
| (Missing) | 79381 |
| Value | Count | Frequency (%) |
| 0 | 17890 | |
| 1 | 7 | < 0.1% |
| 2 | 2 | < 0.1% |
| 3 | 3 | < 0.1% |
| 4 | 2 | < 0.1% |
| 5 | 4 | < 0.1% |
| 6 | 3 | < 0.1% |
| 7 | 4 | < 0.1% |
| 8 | 1 | < 0.1% |
| 9 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 249 | 1 | |
| 233 | 1 | |
| 117 | 1 | |
| 116 | 1 | |
| 91 | 1 | |
| 81 | 1 | |
| 59 | 1 | |
| 58 | 1 | |
| 54 | 1 | |
| 50 | 1 |
DELAY_DUE_LATE_AIRCRAFT
Real number (ℝ)
HIGH CORRELATION  MISSING  ZEROS 
| Distinct | 352 |
|---|---|
| Distinct (%) | 2.0% |
| Missing | 79381 |
| Missing (%) | 81.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 24.84143 |
| Minimum | 0 |
|---|---|
| Maximum | 1018 |
| Zeros | 9369 |
| Zeros (%) | 9.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.5 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 29 |
| 95-th percentile | 115 |
| Maximum | 1018 |
| Range | 1018 |
| Interquartile range (IQR) | 29 |
Descriptive statistics
| Standard deviation | 53.336648 |
|---|---|
| Coefficient of variation (CV) | 2.1470845 |
| Kurtosis | 70.032194 |
| Mean | 24.84143 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 6.1484477 |
| Sum | 446947 |
| Variance | 2844.798 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 9369 | 9.6% |
| 15 | 230 | 0.2% |
| 16 | 200 | 0.2% |
| 17 | 185 | 0.2% |
| 18 | 184 | 0.2% |
| 19 | 170 | 0.2% |
| 12 | 166 | 0.2% |
| 24 | 161 | 0.2% |
| 20 | 156 | 0.2% |
| 13 | 154 | 0.2% |
| Other values (342) | 7017 | 7.2% |
| (Missing) | 79381 |
| Value | Count | Frequency (%) |
| 0 | 9369 | |
| 1 | 129 | 0.1% |
| 2 | 121 | 0.1% |
| 3 | 126 | 0.1% |
| 4 | 117 | 0.1% |
| 5 | 132 | 0.1% |
| 6 | 109 | 0.1% |
| 7 | 134 | 0.1% |
| 8 | 116 | 0.1% |
| 9 | 127 | 0.1% |
| Value | Count | Frequency (%) |
| 1018 | 1 | |
| 1013 | 1 | |
| 1012 | 1 | |
| 960 | 1 | |
| 942 | 1 | |
| 889 | 1 | |
| 888 | 1 | |
| 840 | 1 | |
| 820 | 1 | |
| 802 | 1 |
| AIRLINE | AIRLINE_CODE | AIRLINE_DOT | AIR_TIME | ARR_DELAY | ARR_TIME | CRS_ARR_TIME | CRS_DEP_TIME | CRS_ELAPSED_TIME | DELAY_DUE_CARRIER | DELAY_DUE_LATE_AIRCRAFT | DELAY_DUE_NAS | DELAY_DUE_SECURITY | DELAY_DUE_WEATHER | DEP_DELAY | DEP_TIME | DISTANCE | DIVERTED | DOT_CODE | ELAPSED_TIME | FL_NUMBER | TAXI_IN | TAXI_OUT | WHEELS_OFF | WHEELS_ON | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| AIRLINE | 1.000 | 1.000 | 1.000 | 0.169 | 0.026 | 0.048 | 0.050 | 0.048 | 0.174 | 0.031 | 0.027 | 0.052 | 0.005 | 0.029 | 0.026 | 0.047 | 0.177 | 0.011 | 1.000 | 0.169 | 0.415 | 0.020 | 0.091 | 0.049 | 0.048 |
| AIRLINE_CODE | 1.000 | 1.000 | 1.000 | 0.169 | 0.026 | 0.048 | 0.050 | 0.048 | 0.174 | 0.031 | 0.027 | 0.052 | 0.005 | 0.029 | 0.026 | 0.047 | 0.177 | 0.011 | 1.000 | 0.169 | 0.415 | 0.020 | 0.091 | 0.049 | 0.048 |
| AIRLINE_DOT | 1.000 | 1.000 | 1.000 | 0.169 | 0.026 | 0.048 | 0.050 | 0.048 | 0.174 | 0.031 | 0.027 | 0.052 | 0.005 | 0.029 | 0.026 | 0.047 | 0.177 | 0.011 | 1.000 | 0.169 | 0.415 | 0.020 | 0.091 | 0.049 | 0.048 |
| AIR_TIME | 0.169 | 0.169 | 0.169 | 1.000 | 0.034 | 0.044 | 0.052 | -0.027 | 0.984 | 0.013 | -0.087 | 0.176 | 0.016 | -0.022 | 0.075 | -0.028 | 0.986 | 1.000 | -0.064 | 0.979 | -0.334 | 0.125 | 0.071 | -0.034 | 0.046 |
| ARR_DELAY | 0.026 | 0.026 | 0.026 | 0.034 | 1.000 | 0.110 | 0.112 | 0.130 | -0.027 | 0.210 | 0.339 | 0.004 | -0.011 | 0.136 | 0.655 | 0.166 | 0.004 | 1.000 | -0.033 | 0.099 | -0.039 | 0.119 | 0.269 | 0.171 | 0.117 |
| ARR_TIME | 0.048 | 0.048 | 0.048 | 0.044 | 0.110 | 1.000 | 0.896 | 0.730 | 0.039 | -0.065 | 0.128 | -0.017 | -0.015 | 0.005 | 0.132 | 0.753 | 0.049 | 0.036 | -0.001 | 0.044 | 0.001 | -0.028 | 0.028 | 0.768 | 0.976 |
| CRS_ARR_TIME | 0.050 | 0.050 | 0.050 | 0.052 | 0.112 | 0.896 | 1.000 | 0.794 | 0.049 | -0.048 | 0.210 | -0.052 | -0.013 | 0.004 | 0.144 | 0.792 | 0.060 | 0.017 | 0.001 | 0.049 | -0.007 | -0.037 | 0.025 | 0.800 | 0.904 |
| CRS_DEP_TIME | 0.048 | 0.048 | 0.048 | -0.027 | 0.130 | 0.730 | 0.794 | 1.000 | -0.033 | -0.024 | 0.250 | -0.109 | -0.009 | -0.001 | 0.160 | 0.969 | -0.022 | 0.012 | 0.009 | -0.031 | 0.000 | -0.066 | 0.004 | 0.953 | 0.751 |
| CRS_ELAPSED_TIME | 0.174 | 0.174 | 0.174 | 0.984 | -0.027 | 0.039 | 0.049 | -0.033 | 1.000 | 0.030 | -0.066 | 0.120 | 0.015 | -0.017 | 0.071 | -0.034 | 0.979 | 0.012 | -0.023 | 0.974 | -0.311 | 0.163 | 0.112 | -0.038 | 0.040 |
| DELAY_DUE_CARRIER | 0.031 | 0.031 | 0.031 | 0.013 | 0.210 | -0.065 | -0.048 | -0.024 | 0.030 | 1.000 | -0.251 | -0.368 | -0.058 | -0.226 | 0.303 | -0.020 | 0.039 | 1.000 | -0.062 | -0.042 | -0.024 | -0.122 | -0.139 | -0.026 | -0.066 |
| DELAY_DUE_LATE_AIRCRAFT | 0.027 | 0.027 | 0.027 | -0.087 | 0.339 | 0.128 | 0.210 | 0.250 | -0.066 | -0.251 | 1.000 | -0.297 | -0.013 | -0.043 | 0.452 | 0.278 | -0.056 | 1.000 | -0.056 | -0.151 | -0.017 | -0.079 | -0.198 | 0.259 | 0.139 |
| DELAY_DUE_NAS | 0.052 | 0.052 | 0.052 | 0.176 | 0.004 | -0.017 | -0.052 | -0.109 | 0.120 | -0.368 | -0.297 | 1.000 | -0.013 | -0.013 | -0.377 | -0.125 | 0.106 | 1.000 | 0.128 | 0.330 | -0.056 | 0.296 | 0.444 | -0.100 | -0.019 |
| DELAY_DUE_SECURITY | 0.005 | 0.005 | 0.005 | 0.016 | -0.011 | -0.015 | -0.013 | -0.009 | 0.015 | -0.058 | -0.013 | -0.013 | 1.000 | -0.012 | 0.001 | -0.010 | 0.020 | 1.000 | 0.017 | 0.010 | -0.029 | -0.012 | -0.003 | -0.011 | -0.014 |
| DELAY_DUE_WEATHER | 0.029 | 0.029 | 0.029 | -0.022 | 0.136 | 0.005 | 0.004 | -0.001 | -0.017 | -0.226 | -0.043 | -0.013 | -0.012 | 1.000 | 0.121 | 0.011 | -0.023 | 1.000 | 0.048 | -0.006 | 0.040 | -0.007 | 0.063 | 0.015 | 0.012 |
| DEP_DELAY | 0.026 | 0.026 | 0.026 | 0.075 | 0.655 | 0.132 | 0.144 | 0.160 | 0.071 | 0.303 | 0.452 | -0.377 | 0.001 | 0.121 | 1.000 | 0.203 | 0.085 | 0.018 | -0.174 | 0.074 | -0.084 | -0.051 | 0.020 | 0.199 | 0.141 |
| DEP_TIME | 0.047 | 0.047 | 0.047 | -0.028 | 0.166 | 0.753 | 0.792 | 0.969 | -0.034 | -0.020 | 0.278 | -0.125 | -0.010 | 0.011 | 0.203 | 1.000 | -0.024 | 0.013 | 0.003 | -0.030 | 0.004 | -0.064 | 0.008 | 0.984 | 0.774 |
| DISTANCE | 0.177 | 0.177 | 0.177 | 0.986 | 0.004 | 0.049 | 0.060 | -0.022 | 0.979 | 0.039 | -0.056 | 0.106 | 0.020 | -0.023 | 0.085 | -0.024 | 1.000 | 0.009 | -0.087 | 0.961 | -0.353 | 0.110 | 0.055 | -0.030 | 0.052 |
| DIVERTED | 0.011 | 0.011 | 0.011 | 1.000 | 1.000 | 0.036 | 0.017 | 0.012 | 0.012 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 0.018 | 0.013 | 0.009 | 1.000 | 0.013 | 1.000 | 0.008 | 0.053 | 0.014 | 0.013 | 0.039 |
| DOT_CODE | 1.000 | 1.000 | 1.000 | -0.064 | -0.033 | -0.001 | 0.001 | 0.009 | -0.023 | -0.062 | -0.056 | 0.128 | 0.017 | 0.048 | -0.174 | 0.003 | -0.087 | 0.013 | 1.000 | -0.006 | 0.334 | 0.213 | 0.279 | 0.008 | -0.003 |
| ELAPSED_TIME | 0.169 | 0.169 | 0.169 | 0.979 | 0.099 | 0.044 | 0.049 | -0.031 | 0.974 | -0.042 | -0.151 | 0.330 | 0.010 | -0.006 | 0.074 | -0.030 | 0.961 | 1.000 | -0.006 | 1.000 | -0.305 | 0.209 | 0.203 | -0.032 | 0.046 |
| FL_NUMBER | 0.415 | 0.415 | 0.415 | -0.334 | -0.039 | 0.001 | -0.007 | 0.000 | -0.311 | -0.024 | -0.017 | -0.056 | -0.029 | 0.040 | -0.084 | 0.004 | -0.353 | 0.008 | 0.334 | -0.305 | 1.000 | -0.028 | 0.093 | 0.011 | -0.002 |
| TAXI_IN | 0.020 | 0.020 | 0.020 | 0.125 | 0.119 | -0.028 | -0.037 | -0.066 | 0.163 | -0.122 | -0.079 | 0.296 | -0.012 | -0.007 | -0.051 | -0.064 | 0.110 | 0.053 | 0.213 | 0.209 | -0.028 | 1.000 | 0.067 | -0.063 | -0.036 |
| TAXI_OUT | 0.091 | 0.091 | 0.091 | 0.071 | 0.269 | 0.028 | 0.025 | 0.004 | 0.112 | -0.139 | -0.198 | 0.444 | -0.003 | 0.063 | 0.020 | 0.008 | 0.055 | 0.014 | 0.279 | 0.203 | 0.093 | 0.067 | 1.000 | 0.028 | 0.031 |
| WHEELS_OFF | 0.049 | 0.049 | 0.049 | -0.034 | 0.171 | 0.768 | 0.800 | 0.953 | -0.038 | -0.026 | 0.259 | -0.100 | -0.011 | 0.015 | 0.199 | 0.984 | -0.030 | 0.013 | 0.008 | -0.032 | 0.011 | -0.063 | 0.028 | 1.000 | 0.789 |
| WHEELS_ON | 0.048 | 0.048 | 0.048 | 0.046 | 0.117 | 0.976 | 0.904 | 0.751 | 0.040 | -0.066 | 0.139 | -0.019 | -0.014 | 0.012 | 0.141 | 0.774 | 0.052 | 0.039 | -0.003 | 0.046 | -0.002 | -0.036 | 0.031 | 0.789 | 1.000 |
| FL_DATE | AIRLINE | AIRLINE_DOT | AIRLINE_CODE | DOT_CODE | FL_NUMBER | ORIGIN | ORIGIN_CITY | DEST | DEST_CITY | CRS_DEP_TIME | DEP_TIME | DEP_DELAY | TAXI_OUT | WHEELS_OFF | WHEELS_ON | TAXI_IN | CRS_ARR_TIME | ARR_TIME | ARR_DELAY | CANCELLED | CANCELLATION_CODE | DIVERTED | CRS_ELAPSED_TIME | ELAPSED_TIME | AIR_TIME | DISTANCE | DELAY_DUE_CARRIER | DELAY_DUE_WEATHER | DELAY_DUE_NAS | DELAY_DUE_SECURITY | DELAY_DUE_LATE_AIRCRAFT | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 2019-03-01 | Allegiant Air | Allegiant Air: G4 | G4 | 20368 | 1668 | PGD | Punta Gorda, FL | SPI | Springfield, IL | 630 | 620.0 | -10.0 | 9.0 | 629.0 | 731.0 | 7.0 | 810 | 738.0 | -32.0 | 0.0 | NaN | 0.0 | 160.0 | 138.0 | 122.0 | 994.0 | NaN | NaN | NaN | NaN | NaN |
| 2 | 2022-04-12 | PSA Airlines Inc. | PSA Airlines Inc.: OH | OH | 20397 | 5560 | EWN | New Bern/Morehead/Beaufort, NC | CLT | Charlotte, NC | 625 | 618.0 | -7.0 | 16.0 | 634.0 | 725.0 | 11.0 | 744 | 736.0 | -8.0 | 0.0 | NaN | 0.0 | 79.0 | 78.0 | 51.0 | 221.0 | NaN | NaN | NaN | NaN | NaN |
| 3 | 2021-10-13 | Southwest Airlines Co. | Southwest Airlines Co.: WN | WN | 19393 | 1944 | ABQ | Albuquerque, NM | DEN | Denver, CO | 1715 | 1740.0 | 25.0 | 15.0 | 1755.0 | 1844.0 | 7.0 | 1835 | 1851.0 | 16.0 | 0.0 | NaN | 0.0 | 80.0 | 71.0 | 49.0 | 349.0 | 10.0 | 0.0 | 0.0 | 0.0 | 6.0 |
| 4 | 2022-06-05 | Southwest Airlines Co. | Southwest Airlines Co.: WN | WN | 19393 | 3081 | PIT | Pittsburgh, PA | STL | St. Louis, MO | 535 | 535.0 | 0.0 | 12.0 | 547.0 | 609.0 | 6.0 | 620 | 615.0 | -5.0 | 0.0 | NaN | 0.0 | 105.0 | 100.0 | 82.0 | 554.0 | NaN | NaN | NaN | NaN | NaN |
| 5 | 2019-10-06 | Delta Air Lines Inc. | Delta Air Lines Inc.: DL | DL | 19790 | 674 | LAX | Los Angeles, CA | SEA | Seattle, WA | 1140 | 1138.0 | -2.0 | 14.0 | 1152.0 | 1405.0 | 11.0 | 1438 | 1416.0 | -22.0 | 0.0 | NaN | 0.0 | 178.0 | 158.0 | 133.0 | 954.0 | NaN | NaN | NaN | NaN | NaN |
| 6 | 2020-03-17 | Southwest Airlines Co. | Southwest Airlines Co.: WN | WN | 19393 | 443 | OAK | Oakland, CA | HOU | Houston, TX | 2000 | 2019.0 | 19.0 | 13.0 | 2032.0 | 143.0 | 7.0 | 135 | 150.0 | 15.0 | 0.0 | NaN | 0.0 | 215.0 | 211.0 | 191.0 | 1642.0 | 15.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 7 | 2020-02-06 | Southwest Airlines Co. | Southwest Airlines Co.: WN | WN | 19393 | 1779 | SFO | San Francisco, CA | SAN | San Diego, CA | 1340 | 1338.0 | -2.0 | 13.0 | 1351.0 | 1456.0 | 3.0 | 1520 | 1459.0 | -21.0 | 0.0 | NaN | 0.0 | 100.0 | 81.0 | 65.0 | 447.0 | NaN | NaN | NaN | NaN | NaN |
| 8 | 2019-03-11 | Delta Air Lines Inc. | Delta Air Lines Inc.: DL | DL | 19790 | 2135 | DTW | Detroit, MI | LAS | Las Vegas, NV | 714 | 710.0 | -4.0 | 30.0 | 740.0 | 854.0 | 10.0 | 847 | 904.0 | 17.0 | 0.0 | NaN | 0.0 | 273.0 | 294.0 | 254.0 | 1749.0 | 0.0 | 0.0 | 17.0 | 0.0 | 0.0 |
| 9 | 2022-07-24 | Delta Air Lines Inc. | Delta Air Lines Inc.: DL | DL | 19790 | 1612 | DEN | Denver, CO | SLC | Salt Lake City, UT | 2010 | 2038.0 | 28.0 | 16.0 | 2054.0 | 2159.0 | 5.0 | 2148 | 2204.0 | 16.0 | 0.0 | NaN | 0.0 | 98.0 | 86.0 | 65.0 | 391.0 | 16.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 10 | 2021-07-10 | United Air Lines Inc. | United Air Lines Inc.: UA | UA | 19977 | 1185 | SLC | Salt Lake City, UT | IAH | Houston, TX | 1502 | 1505.0 | 3.0 | 17.0 | 1522.0 | 1847.0 | 8.0 | 1900 | 1855.0 | -5.0 | 0.0 | NaN | 0.0 | 178.0 | 170.0 | 145.0 | 1195.0 | NaN | NaN | NaN | NaN | NaN |
| FL_DATE | AIRLINE | AIRLINE_DOT | AIRLINE_CODE | DOT_CODE | FL_NUMBER | ORIGIN | ORIGIN_CITY | DEST | DEST_CITY | CRS_DEP_TIME | DEP_TIME | DEP_DELAY | TAXI_OUT | WHEELS_OFF | WHEELS_ON | TAXI_IN | CRS_ARR_TIME | ARR_TIME | ARR_DELAY | CANCELLED | CANCELLATION_CODE | DIVERTED | CRS_ELAPSED_TIME | ELAPSED_TIME | AIR_TIME | DISTANCE | DELAY_DUE_CARRIER | DELAY_DUE_WEATHER | DELAY_DUE_NAS | DELAY_DUE_SECURITY | DELAY_DUE_LATE_AIRCRAFT | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 99990 | 2019-02-19 | Southwest Airlines Co. | Southwest Airlines Co.: WN | WN | 19393 | 377 | DEN | Denver, CO | SEA | Seattle, WA | 855 | 857.0 | 2.0 | 14.0 | 911.0 | 1043.0 | 4.0 | 1100 | 1047.0 | -13.0 | 0.0 | NaN | 0.0 | 185.0 | 170.0 | 152.0 | 1024.0 | NaN | NaN | NaN | NaN | NaN |
| 99991 | 2019-02-21 | Southwest Airlines Co. | Southwest Airlines Co.: WN | WN | 19393 | 1752 | BWI | Baltimore, MD | TPA | Tampa, FL | 825 | 825.0 | 0.0 | 30.0 | 855.0 | 1102.0 | 6.0 | 1050 | 1108.0 | 18.0 | 0.0 | NaN | 0.0 | 145.0 | 163.0 | 127.0 | 842.0 | 0.0 | 0.0 | 18.0 | 0.0 | 0.0 |
| 99992 | 2022-06-29 | Delta Air Lines Inc. | Delta Air Lines Inc.: DL | DL | 19790 | 1643 | ATL | Atlanta, GA | MSN | Madison, WI | 950 | 946.0 | -4.0 | 9.0 | 955.0 | 1036.0 | 8.0 | 1048 | 1044.0 | -4.0 | 0.0 | NaN | 0.0 | 118.0 | 118.0 | 101.0 | 707.0 | NaN | NaN | NaN | NaN | NaN |
| 99993 | 2023-01-06 | Spirit Air Lines | Spirit Air Lines: NK | NK | 20416 | 1042 | SJU | San Juan, PR | MCO | Orlando, FL | 2130 | 2225.0 | 55.0 | 14.0 | 2239.0 | 17.0 | 39.0 | 2350 | 56.0 | 66.0 | 0.0 | NaN | 0.0 | 200.0 | 211.0 | 158.0 | 1189.0 | 0.0 | 0.0 | 11.0 | 0.0 | 55.0 |
| 99994 | 2023-08-05 | United Air Lines Inc. | United Air Lines Inc.: UA | UA | 19977 | 1478 | LAS | Las Vegas, NV | IAH | Houston, TX | 1023 | 1016.0 | -7.0 | 30.0 | 1046.0 | 1517.0 | 3.0 | 1533 | 1520.0 | -13.0 | 0.0 | NaN | 0.0 | 190.0 | 184.0 | 151.0 | 1222.0 | NaN | NaN | NaN | NaN | NaN |
| 99995 | 2019-02-26 | Delta Air Lines Inc. | Delta Air Lines Inc.: DL | DL | 19790 | 2229 | CHS | Charleston, SC | ATL | Atlanta, GA | 1244 | 1241.0 | -3.0 | 13.0 | 1254.0 | 1344.0 | 10.0 | 1408 | 1354.0 | -14.0 | 0.0 | NaN | 0.0 | 84.0 | 73.0 | 50.0 | 259.0 | NaN | NaN | NaN | NaN | NaN |
| 99996 | 2023-02-10 | Southwest Airlines Co. | Southwest Airlines Co.: WN | WN | 19393 | 2977 | MDW | Chicago, IL | LAX | Los Angeles, CA | 925 | 1134.0 | 129.0 | 19.0 | 1153.0 | 1322.0 | 11.0 | 1205 | 1333.0 | 88.0 | 0.0 | NaN | 0.0 | 280.0 | 239.0 | 209.0 | 1750.0 | 88.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 99997 | 2019-06-26 | Endeavor Air Inc. | Endeavor Air Inc.: 9E | 9E | 20363 | 5003 | ORF | Norfolk, VA | JFK | New York, NY | 1712 | 1715.0 | 3.0 | 25.0 | 1740.0 | 1831.0 | 6.0 | 1845 | 1837.0 | -8.0 | 0.0 | NaN | 0.0 | 93.0 | 82.0 | 51.0 | 290.0 | NaN | NaN | NaN | NaN | NaN |
| 99998 | 2023-06-22 | Endeavor Air Inc. | Endeavor Air Inc.: 9E | 9E | 20363 | 5173 | CVG | Cincinnati, OH | LGA | New York, NY | 1433 | 1436.0 | 3.0 | 14.0 | 1450.0 | 1617.0 | 9.0 | 1640 | 1626.0 | -14.0 | 0.0 | NaN | 0.0 | 127.0 | 110.0 | 87.0 | 585.0 | NaN | NaN | NaN | NaN | NaN |
| 99999 | 2022-01-07 | Endeavor Air Inc. | Endeavor Air Inc.: 9E | 9E | 20363 | 5227 | ATL | Atlanta, GA | SHV | Shreveport, LA | 1345 | 1420.0 | 35.0 | 10.0 | 1430.0 | 1456.0 | 4.0 | 1438 | 1500.0 | 22.0 | 0.0 | NaN | 0.0 | 113.0 | 100.0 | 86.0 | 551.0 | 0.0 | 0.0 | 0.0 | 0.0 | 22.0 |